package com.neudu.yyzx_service.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.neudu.yyzx_service.pojo.Bed;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface BedMapper extends BaseMapper<Bed> {
    @Select("SELECT * FROM bed WHERE id = #{id}")
    Bed getBedById(Long id);

    List<Bed> get_all_building();
    List<Bed> get_all_room();
    List<Bed> get_all_bed();
    List<Bed> getbed_by_buildingroom(Integer buildingNo,Integer roomNo);
    List<Bed> getroom_by_building(Integer buildingNo);
}